using System;
using System.Collections.Generic;
using System.Text;
using Shc.Sql;
using Shc.Json;
namespace CLZ.Data
{
	public static class TableViewVegetablesPrice
	{
		public const string Table = "View_VegetablesPrice";
		public const string ImageUrl = "ImageUrl";
		public const string Sort = "Sort";
		public const string VegetablesStatus = "VegetablesStatus";
		public const string SalesGuidePrice = "SalesGuidePrice";
		public const string OriginalPrice = "OriginalPrice";
		public const string VegetablesName = "VegetablesName";
		public const string NumberOfUnitsID = "NumberOfUnitsID";
		public const string VegetablesTypeID = "VegetablesTypeID";
		public const string VegetablesPriceID = "VegetablesPriceID";
		public const string BusinessVegetablesPriceID = "BusinessVegetablesPriceID";
		public const string VegetablesID = "VegetablesID";
		public const string NowOriginalPrice = "NowOriginalPrice";
		public const string NowSalesGuidePrice = "NowSalesGuidePrice";
		public const string SetDate = "SetDate";
		public const string HomeProductTypeID = "HomeProductTypeID";
		public const string BusinessID = "BusinessID";
		public const string NumberOfUnitsName = "NumberOfUnitsName";
		public const string VegetablesTypeName = "VegetablesTypeName";
		public const string Specification = "Specification";
		public const string VegetablesNo = "VegetablesNo";
		public const string CookingMethods = "CookingMethods";
		public const string Description = "Description";
		public const string BusinessName = "BusinessName";
		public const string BusinessNo = "BusinessNo";
		public const string MarketsName = "MarketsName";
		public const string SalesTypeID = "SalesTypeID";
		public const string Weigth = "Weigth";
		public const string ProductType = "ProductType";
		public const string HomeProductTypeName = "HomeProductTypeName";
		public const string HomeProductTypeSort = "HomeProductTypeSort";
		public const string BigImageUrl = "BigImageUrl";
		public const string TotalQty = "TotalQty";
		public const string IsWeight = "IsWeight";
		public const string WeightCount = "WeightCount";
	}
	
	[Serializable]
	public class BaseViewVegetablesPrice
		: IDbSessionEntity, IJsonClass
	{
		string m_ImageUrl;
		/// <summary>
        /// 
        /// </summary>
        public string ImageUrl
        {
            get { return m_ImageUrl; }
            set { m_ImageUrl = value; }
        }
		
		int m_Sort;
		/// <summary>
        /// 
        /// </summary>
        public int Sort
        {
            get { return m_Sort; }
            set { m_Sort = value; }
        }
		
		int m_VegetablesStatus;
		/// <summary>
        /// 
        /// </summary>
        public int VegetablesStatus
        {
            get { return m_VegetablesStatus; }
            set { m_VegetablesStatus = value; }
        }
		
		double m_SalesGuidePrice;
		/// <summary>
        /// 
        /// </summary>
        public double SalesGuidePrice
        {
            get { return m_SalesGuidePrice; }
            set { m_SalesGuidePrice = value; }
        }
		
		double m_OriginalPrice;
		/// <summary>
        /// 
        /// </summary>
        public double OriginalPrice
        {
            get { return m_OriginalPrice; }
            set { m_OriginalPrice = value; }
        }
		
		string m_VegetablesName;
		/// <summary>
        /// 
        /// </summary>
        public string VegetablesName
        {
            get { return m_VegetablesName; }
            set { m_VegetablesName = value; }
        }
		
		int? m_NumberOfUnitsID;
		/// <summary>
        /// 
        /// </summary>
        public int? NumberOfUnitsID
        {
            get { return m_NumberOfUnitsID; }
            set { m_NumberOfUnitsID = value; }
        }
		
		int? m_VegetablesTypeID;
		/// <summary>
        /// 
        /// </summary>
        public int? VegetablesTypeID
        {
            get { return m_VegetablesTypeID; }
            set { m_VegetablesTypeID = value; }
        }
		
		int m_VegetablesPriceID;
		/// <summary>
        /// 
        /// </summary>
        public int VegetablesPriceID
        {
            get { return m_VegetablesPriceID; }
            set { m_VegetablesPriceID = value; }
        }
		
		int? m_BusinessVegetablesPriceID;
		/// <summary>
        /// 
        /// </summary>
        public int? BusinessVegetablesPriceID
        {
            get { return m_BusinessVegetablesPriceID; }
            set { m_BusinessVegetablesPriceID = value; }
        }
		
		int? m_VegetablesID;
		/// <summary>
        /// 
        /// </summary>
        public int? VegetablesID
        {
            get { return m_VegetablesID; }
            set { m_VegetablesID = value; }
        }
		
		double m_NowOriginalPrice;
		/// <summary>
        /// 
        /// </summary>
        public double NowOriginalPrice
        {
            get { return m_NowOriginalPrice; }
            set { m_NowOriginalPrice = value; }
        }
		
		double m_NowSalesGuidePrice;
		/// <summary>
        /// 
        /// </summary>
        public double NowSalesGuidePrice
        {
            get { return m_NowSalesGuidePrice; }
            set { m_NowSalesGuidePrice = value; }
        }
		
		DateTime m_SetDate;
		/// <summary>
        /// 
        /// </summary>
        public DateTime SetDate
        {
            get { return m_SetDate; }
            set { m_SetDate = value; }
        }
		
		int m_HomeProductTypeID;
		/// <summary>
        /// 
        /// </summary>
        public int HomeProductTypeID
        {
            get { return m_HomeProductTypeID; }
            set { m_HomeProductTypeID = value; }
        }
		
		int? m_BusinessID;
		/// <summary>
        /// 
        /// </summary>
        public int? BusinessID
        {
            get { return m_BusinessID; }
            set { m_BusinessID = value; }
        }
		
		string m_NumberOfUnitsName;
		/// <summary>
        /// 
        /// </summary>
        public string NumberOfUnitsName
        {
            get { return m_NumberOfUnitsName; }
            set { m_NumberOfUnitsName = value; }
        }
		
		string m_VegetablesTypeName;
		/// <summary>
        /// 
        /// </summary>
        public string VegetablesTypeName
        {
            get { return m_VegetablesTypeName; }
            set { m_VegetablesTypeName = value; }
        }
		
		string m_Specification;
		/// <summary>
        /// 
        /// </summary>
        public string Specification
        {
            get { return m_Specification; }
            set { m_Specification = value; }
        }
		
		string m_VegetablesNo;
		/// <summary>
        /// 
        /// </summary>
        public string VegetablesNo
        {
            get { return m_VegetablesNo; }
            set { m_VegetablesNo = value; }
        }
		
		string m_CookingMethods;
		/// <summary>
        /// 
        /// </summary>
        public string CookingMethods
        {
            get { return m_CookingMethods; }
            set { m_CookingMethods = value; }
        }
		
		string m_Description;
		/// <summary>
        /// 
        /// </summary>
        public string Description
        {
            get { return m_Description; }
            set { m_Description = value; }
        }
		
		string m_BusinessName;
		/// <summary>
        /// 
        /// </summary>
        public string BusinessName
        {
            get { return m_BusinessName; }
            set { m_BusinessName = value; }
        }
		
		string m_BusinessNo;
		/// <summary>
        /// 
        /// </summary>
        public string BusinessNo
        {
            get { return m_BusinessNo; }
            set { m_BusinessNo = value; }
        }
		
		string m_MarketsName;
		/// <summary>
        /// 
        /// </summary>
        public string MarketsName
        {
            get { return m_MarketsName; }
            set { m_MarketsName = value; }
        }
		
		int? m_SalesTypeID;
		/// <summary>
        /// 
        /// </summary>
        public int? SalesTypeID
        {
            get { return m_SalesTypeID; }
            set { m_SalesTypeID = value; }
        }
		
		double m_Weigth;
		/// <summary>
        /// 
        /// </summary>
        public double Weigth
        {
            get { return m_Weigth; }
            set { m_Weigth = value; }
        }
		
		int m_ProductType;
		/// <summary>
        /// 
        /// </summary>
        public int ProductType
        {
            get { return m_ProductType; }
            set { m_ProductType = value; }
        }
		
		string m_HomeProductTypeName;
		/// <summary>
        /// 
        /// </summary>
        public string HomeProductTypeName
        {
            get { return m_HomeProductTypeName; }
            set { m_HomeProductTypeName = value; }
        }
		
		int? m_HomeProductTypeSort;
		/// <summary>
        /// 
        /// </summary>
        public int? HomeProductTypeSort
        {
            get { return m_HomeProductTypeSort; }
            set { m_HomeProductTypeSort = value; }
        }
		
		string m_BigImageUrl;
		/// <summary>
        /// 
        /// </summary>
        public string BigImageUrl
        {
            get { return m_BigImageUrl; }
            set { m_BigImageUrl = value; }
        }
		
		double? m_TotalQty;
		/// <summary>
        /// 
        /// </summary>
        public double? TotalQty
        {
            get { return m_TotalQty; }
            set { m_TotalQty = value; }
        }
		
		bool m_IsWeight;
		/// <summary>
        /// 
        /// </summary>
        public bool IsWeight
        {
            get { return m_IsWeight; }
            set { m_IsWeight = value; }
        }
		
		int m_WeightCount;
		/// <summary>
        /// 
        /// </summary>
        public int WeightCount
        {
            get { return m_WeightCount; }
            set { m_WeightCount = value; }
        }
		
		
		#region IDbSessionEntity Members
		public void ReadDBData(RowDataReader reader)
        {
            m_ImageUrl = reader[TableViewVegetablesPrice.ImageUrl];
            m_Sort = reader[TableViewVegetablesPrice.Sort];
            m_VegetablesStatus = reader[TableViewVegetablesPrice.VegetablesStatus];
            m_SalesGuidePrice = reader[TableViewVegetablesPrice.SalesGuidePrice];
            m_OriginalPrice = reader[TableViewVegetablesPrice.OriginalPrice];
            m_VegetablesName = reader[TableViewVegetablesPrice.VegetablesName];
            m_NumberOfUnitsID = reader[TableViewVegetablesPrice.NumberOfUnitsID];
            m_VegetablesTypeID = reader[TableViewVegetablesPrice.VegetablesTypeID];
            m_VegetablesPriceID = reader[TableViewVegetablesPrice.VegetablesPriceID];
            m_BusinessVegetablesPriceID = reader[TableViewVegetablesPrice.BusinessVegetablesPriceID];
            m_VegetablesID = reader[TableViewVegetablesPrice.VegetablesID];
            m_NowOriginalPrice = reader[TableViewVegetablesPrice.NowOriginalPrice];
            m_NowSalesGuidePrice = reader[TableViewVegetablesPrice.NowSalesGuidePrice];
            m_SetDate = reader[TableViewVegetablesPrice.SetDate];
            m_HomeProductTypeID = reader[TableViewVegetablesPrice.HomeProductTypeID];
            m_BusinessID = reader[TableViewVegetablesPrice.BusinessID];
            m_NumberOfUnitsName = reader[TableViewVegetablesPrice.NumberOfUnitsName];
            m_VegetablesTypeName = reader[TableViewVegetablesPrice.VegetablesTypeName];
            m_Specification = reader[TableViewVegetablesPrice.Specification];
            m_VegetablesNo = reader[TableViewVegetablesPrice.VegetablesNo];
            m_CookingMethods = reader[TableViewVegetablesPrice.CookingMethods];
            m_Description = reader[TableViewVegetablesPrice.Description];
            m_BusinessName = reader[TableViewVegetablesPrice.BusinessName];
            m_BusinessNo = reader[TableViewVegetablesPrice.BusinessNo];
            m_MarketsName = reader[TableViewVegetablesPrice.MarketsName];
            m_SalesTypeID = reader[TableViewVegetablesPrice.SalesTypeID];
            m_Weigth = reader[TableViewVegetablesPrice.Weigth];
            m_ProductType = reader[TableViewVegetablesPrice.ProductType];
            m_HomeProductTypeName = reader[TableViewVegetablesPrice.HomeProductTypeName];
            m_HomeProductTypeSort = reader[TableViewVegetablesPrice.HomeProductTypeSort];
            m_BigImageUrl = reader[TableViewVegetablesPrice.BigImageUrl];
            m_TotalQty = reader[TableViewVegetablesPrice.TotalQty];
            m_IsWeight = reader[TableViewVegetablesPrice.IsWeight];
            m_WeightCount = reader[TableViewVegetablesPrice.WeightCount];
        }
		
		public void WriteDBData(RowDataWriter writer)
        {
        }

        public void SetIdentityAfterInsert(DBObject idd)
        {
        }
		
		public string TableName
        {
            get { return TableViewVegetablesPrice.Table; }
        }
		#endregion
		
		
		#region IJsonClass Members

        public void JsonDeSerializeObj(JsonHashTable hashToRead)
        {
             m_ImageUrl = hashToRead["ImageUrl"];
			 
             m_Sort = hashToRead["Sort"];
			 
             m_VegetablesStatus = hashToRead["VegetablesStatus"];
			 
             m_SalesGuidePrice = hashToRead["SalesGuidePrice"];
			 
             m_OriginalPrice = hashToRead["OriginalPrice"];
			 
             m_VegetablesName = hashToRead["VegetablesName"];
			 
             m_NumberOfUnitsID = hashToRead["NumberOfUnitsID"];
			 
             m_VegetablesTypeID = hashToRead["VegetablesTypeID"];
			 
             m_VegetablesPriceID = hashToRead["VegetablesPriceID"];
			 
             m_BusinessVegetablesPriceID = hashToRead["BusinessVegetablesPriceID"];
			 
             m_VegetablesID = hashToRead["VegetablesID"];
			 
             m_NowOriginalPrice = hashToRead["NowOriginalPrice"];
			 
             m_NowSalesGuidePrice = hashToRead["NowSalesGuidePrice"];
			 
             m_SetDate = hashToRead["SetDate"];
			 
             m_HomeProductTypeID = hashToRead["HomeProductTypeID"];
			 
             m_BusinessID = hashToRead["BusinessID"];
			 
             m_NumberOfUnitsName = hashToRead["NumberOfUnitsName"];
			 
             m_VegetablesTypeName = hashToRead["VegetablesTypeName"];
			 
             m_Specification = hashToRead["Specification"];
			 
             m_VegetablesNo = hashToRead["VegetablesNo"];
			 
             m_CookingMethods = hashToRead["CookingMethods"];
			 
             m_Description = hashToRead["Description"];
			 
             m_BusinessName = hashToRead["BusinessName"];
			 
             m_BusinessNo = hashToRead["BusinessNo"];
			 
             m_MarketsName = hashToRead["MarketsName"];
			 
             m_SalesTypeID = hashToRead["SalesTypeID"];
			 
             m_Weigth = hashToRead["Weigth"];
			 
             m_ProductType = hashToRead["ProductType"];
			 
             m_HomeProductTypeName = hashToRead["HomeProductTypeName"];
			 
             m_HomeProductTypeSort = hashToRead["HomeProductTypeSort"];
			 
             m_BigImageUrl = hashToRead["BigImageUrl"];
			 
             m_TotalQty = hashToRead["TotalQty"];
			 
             m_IsWeight = hashToRead["IsWeight"];
			 
             m_WeightCount = hashToRead["WeightCount"];
			 
        }

        public void JsonSerializeObj(JsonHashTable hashToFill)
        {
            hashToFill["ImageUrl"] = ImageUrl;
			
            hashToFill["Sort"] = Sort;
			
            hashToFill["VegetablesStatus"] = VegetablesStatus;
			
            hashToFill["SalesGuidePrice"] = SalesGuidePrice;
			
            hashToFill["OriginalPrice"] = OriginalPrice;
			
            hashToFill["VegetablesName"] = VegetablesName;
			
            hashToFill["NumberOfUnitsID"] = NumberOfUnitsID;
			
            hashToFill["VegetablesTypeID"] = VegetablesTypeID;
			
            hashToFill["VegetablesPriceID"] = VegetablesPriceID;
			
            hashToFill["BusinessVegetablesPriceID"] = BusinessVegetablesPriceID;
			
            hashToFill["VegetablesID"] = VegetablesID;
			
            hashToFill["NowOriginalPrice"] = NowOriginalPrice;
			
            hashToFill["NowSalesGuidePrice"] = NowSalesGuidePrice;
			
            hashToFill["SetDate"] = SetDate;
			
            hashToFill["HomeProductTypeID"] = HomeProductTypeID;
			
            hashToFill["BusinessID"] = BusinessID;
			
            hashToFill["NumberOfUnitsName"] = NumberOfUnitsName;
			
            hashToFill["VegetablesTypeName"] = VegetablesTypeName;
			
            hashToFill["Specification"] = Specification;
			
            hashToFill["VegetablesNo"] = VegetablesNo;
			
            hashToFill["CookingMethods"] = CookingMethods;
			
            hashToFill["Description"] = Description;
			
            hashToFill["BusinessName"] = BusinessName;
			
            hashToFill["BusinessNo"] = BusinessNo;
			
            hashToFill["MarketsName"] = MarketsName;
			
            hashToFill["SalesTypeID"] = SalesTypeID;
			
            hashToFill["Weigth"] = Weigth;
			
            hashToFill["ProductType"] = ProductType;
			
            hashToFill["HomeProductTypeName"] = HomeProductTypeName;
			
            hashToFill["HomeProductTypeSort"] = HomeProductTypeSort;
			
            hashToFill["BigImageUrl"] = BigImageUrl;
			
            hashToFill["TotalQty"] = TotalQty;
			
            hashToFill["IsWeight"] = IsWeight;
			
            hashToFill["WeightCount"] = WeightCount;
			
        }

        #endregion
		
	}
}
